﻿ DROP TABLE ICC_ABPOS_MAT
GO
  CREATE TABLE "INTEX"."ICC_ABPOS_MAT"
   (
      "ABPSPGRD" CHAR(2),
       "ABPGESSTA" CHAR(2),
        "ABPAUFPOS" CHAR(3),
        "ABPART" CHAR(20), 
        "ABPVAR" CHAR(3),
        "ABPFARBE" CHAR(10),
        "UM" CHAR(3),
         "RATIO"  NUMBER(9),
         "TQTY" NUMBER(9),
		 "DQTY" NUMBER(9),
         "S" NUMBER(9),
         "M" NUMBER(9),
           "L" NUMBER(9),
             "XL" NUMBER(9),
"TQTYP" NUMBER(9),
         "SP" NUMBER(9),
          "MP" NUMBER(9),
           "LP" NUMBER(9),
             "XLP" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"
GO

 DROP TABLE ICC_MDECKMAT
GO
  CREATE TABLE "INTEX"."ICC_MDECKMAT"
   (
        "AUFPOS" CHAR(3),
        "ART" CHAR(20),
        "VAR" CHAR(3),
        "FARBE" CHAR(10),
                        "UM" CHAR(3),
        "RATIO"  NUMBER(9),
         "TQTY" NUMBER(9),
         "S" NUMBER(9),
         "M" NUMBER(9),
           "L" NUMBER(9),
             "XL" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO
 DROP TABLE ICC_WDECKMAT
GO
  CREATE TABLE "INTEX"."ICC_WDECKMAT"
   (
        "AUFPOS" CHAR(3),
        "ART" CHAR(20),
        "VAR" CHAR(3),
        "FARBE" CHAR(10),
                        "UM" CHAR(3),
        "RATIO"  NUMBER(9),
         "TQTY" NUMBER(9),
         "S" NUMBER(9),
         "M" NUMBER(9),
           "L" NUMBER(9),
             "XL" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO
 DROP TABLE ICC_FDECKMAT
GO
  CREATE TABLE "INTEX"."ICC_FDECKMAT"
   (
        "AUFPOS" CHAR(3),
        "ART" CHAR(20),
        "VAR" CHAR(3),
        "FARBE" CHAR(10),
        "SIZE" CHAR(10),
                        "UM" CHAR(3),
        "RATIO"  NUMBER(9),
         "TQTY" NUMBER(9),
         "S" NUMBER(9),
         "M" NUMBER(9),
           "L" NUMBER(9),
             "XL" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO
 DROP TABLE ICC_GAAUFMAT
GO
  CREATE TABLE "INTEX"."ICC_GAAUFMAT"
   (
        "AUFPOS" CHAR(3),
        "ART" CHAR(20),
        "VAR" CHAR(3),
        "FARBE" CHAR(10),
                "UM" CHAR(3),
				        "RATIO"  NUMBER(9),
         "TQTY" NUMBER(9),
         "S" NUMBER(9),
         "M" NUMBER(9),
           "L" NUMBER(9),
             "XL" NUMBER(9)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO
